Operational data is a key asset to the organization, but sometimes such data is generally not utilized to its full potential. Thus, the fundamental goal of the data warehouse is to enable user's appropriate access to a homogenized and comprehensive view of the organization, supporting forecasting and decision-making processes at the enterprise level. An additional goal of the data warehouse is to achieve information consistency. By bringing data from different data sources into a centralized repository, the data warehouse provides a homogenized view of the organization's data.

DWH is designed to keep all these things in mind. It is designed in a way that maximum can be utilized from the organization data. It utilizes data by showing it in three layers. The top layer is designed to keep in mind the high level authorities or policy makers(CEO, CFO, President, Vice President etc) that are interested in yearly data for all the locations. Second layer is for middle level authorities(General manager, Plant manager, Regional manager, Divisional manager etc) which are interested in one particular only for period of time. Third layer is for first level authorities(Office manager, Shift supervisor, Department manager etc) that are interested in one division of one location only for period of time.

DWH uses consistent data so whatever be the drill down level, data will be same. Inconsistent data may create a situation of confusion so consistency is necessarily maintained.

The major benefits of maintaining a data warehouse are summarized below :

•  Empowers decision-makers by enabling direct access to accurate, consistent, and non-volatile information and by offering decision-support services that will facilitate the analysis and interpretation of Institutional data.
•  Redirects costly personnel hours from data gathering, matching and consolidating to data analysis. Reduces the need for information consumers to replicate data and maintain redundant tracking systems.
•  Promotes the no walls culture. The information sharing will lower the walls among all administrative and academic units, creating alliances and connecting people to each other and the Institute as a whole.
•  Improves data quality over time. Broader access to information will help better to define what types of information we need on hand for effective decision-making. This will identify areas for improvement in data gathering functions and data entry.
•  Enhances organizational effectiveness by extending and expanding the use of management information across the organization. The extensive use of management information will eventually promote the analytical culture that places value on information and analysis.
•  Improves integrity and conformity of organization-wide information. As more people in organization use the data, error will be identified and corrected thereby improving data integrity over time.
•  Improves access to the historical data. Historical data will be available to the broader campus community for ad hoc access and analytical processing.
•  Provides direct support to Institute executives and the organizations in collection, analysis, interpretation, and provision of Institute information.